﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 公告表实体类：fanli_news 。
	/// </summary>
	[Serializable]
	public class fanli_news
	{
		public fanli_news()
		{}

		#region Model
		private int _id; //id
		private int _cata; //类别
		private string _title; //标题
		private string _content; //内容
		private DateTime? _pubDate; //发布日期
		private string _sourceUrl; //来源
		private int _hits; //点击
		private int _ishot; //是否推荐
		private int _sortid; //是否置顶
		private string _ext; //扩展


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 类别
		/// </summary>
		public int cata
		{
			set{ _cata=value;}
			get{return _cata;}
		}
        /// <summary>
		/// 标题
		/// </summary>
		public string title
		{
			set{ _title=value;}
			get{return _title;}
		}
        /// <summary>
		/// 内容
		/// </summary>
		public string content
		{
			set{ _content=value;}
			get{return _content;}
		}
        /// <summary>
		/// 发布日期
		/// </summary>
		public DateTime? pubDate
		{
			set{ _pubDate=value;}
			get{return _pubDate;}
		}
        /// <summary>
		/// 来源
		/// </summary>
		public string sourceUrl
		{
			set{ _sourceUrl=value;}
			get{return _sourceUrl;}
		}
        /// <summary>
		/// 点击
		/// </summary>
		public int hits
		{
			set{ _hits=value;}
			get{return _hits;}
		}
        /// <summary>
		/// 是否推荐
		/// </summary>
		public int ishot
		{
			set{ _ishot=value;}
			get{return _ishot;}
		}
        /// <summary>
		/// 是否置顶
		/// </summary>
		public int sortid
		{
			set{ _sortid=value;}
			get{return _sortid;}
		}
        /// <summary>
		/// 扩展
		/// </summary>
		public string ext
		{
			set{ _ext=value;}
			get{return _ext;}
		}
		#endregion Model

		#region txt document
		/*
公告表,news
id,类别,标题,内容,发布日期,来源,点击,是否推荐,是否置顶,扩展
id,cata,title,content,pubDate,sourceUrl,hits,ishot,sortid,ext
i,i,c256,t,d,c256,i,i,i,c100

--------------------------
-- 创建表[公告表]开始: 
-- alter table  [fanli_news] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_news') drop table fanli_news
  CREATE TABLE [fanli_news] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [cata] int,
	 [title] [varchar] (256),
	 [content] [text],
	 [pubDate] [datetime],
	 [sourceUrl] [varchar] (256),
	 [hits] int,
	 [ishot] int,
	 [sortid] int,
	 [ext] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'公告表 ',N'user',N'dbo',N'table',N'fanli_news', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_news',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'类别',N'user',N'dbo',N'table',N'fanli_news',N'column',N'cata'
 exec sp_addextendedproperty N'MS_Description',N'标题',N'user',N'dbo',N'table',N'fanli_news',N'column',N'title'
 exec sp_addextendedproperty N'MS_Description',N'内容',N'user',N'dbo',N'table',N'fanli_news',N'column',N'content'
 exec sp_addextendedproperty N'MS_Description',N'发布日期',N'user',N'dbo',N'table',N'fanli_news',N'column',N'pubDate'
 exec sp_addextendedproperty N'MS_Description',N'来源',N'user',N'dbo',N'table',N'fanli_news',N'column',N'sourceUrl'
 exec sp_addextendedproperty N'MS_Description',N'点击',N'user',N'dbo',N'table',N'fanli_news',N'column',N'hits'
 exec sp_addextendedproperty N'MS_Description',N'是否推荐',N'user',N'dbo',N'table',N'fanli_news',N'column',N'ishot'
 exec sp_addextendedproperty N'MS_Description',N'是否置顶',N'user',N'dbo',N'table',N'fanli_news',N'column',N'sortid'
 exec sp_addextendedproperty N'MS_Description',N'扩展',N'user',N'dbo',N'table',N'fanli_news',N'column',N'ext'

-- 创建表[公告表]结束。 
--------------------------

		*/
		#endregion document
	}
}

